Overview

Brought to you by YData

Dataset statistics

Number of variables	24
Number of observations	1048532
Missing cells	5155045
Missing cells (%)	20.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.2 GiB
Average record size in memory	1.2 KiB

Variable types

Numeric	1
Categorical	12
Text	10
DateTime	1

Alerts

`Acceptance Status` is highly overall correlated with `Acceptance to Installation Days` and 5 other fields	High correlation
`Acceptance to Installation Days` is highly overall correlated with `Acceptance Status`	High correlation
`Approval to Vendor Selection Days` is highly overall correlated with `Acceptance Status`	High correlation
`Inspection to Subsidy Redeemed Days` is highly overall correlated with `Acceptance Status`	High correlation
`Installation to Inspection Days` is highly overall correlated with `Acceptance Status`	High correlation
`Registration to Approval Days` is highly overall correlated with `Acceptance Status`	High correlation
`Vendor Selection to Acceptance Days` is highly overall correlated with `Acceptance Status`	High correlation
`Registration to Approval Days` has 736435 (70.2%) missing values	Missing
`Approval to Vendor Selection Days` has 736435 (70.2%) missing values	Missing
`Vendor Selection to Acceptance Days` has 736435 (70.2%) missing values	Missing
`Acceptance to Installation Days` has 736435 (70.2%) missing values	Missing
`Installation to Inspection Days` has 736435 (70.2%) missing values	Missing
`Inspection to Subsidy Redeemed Days` has 736435 (70.2%) missing values	Missing
`Subsidy Redeemed to Released Days` has 736435 (70.2%) missing values	Missing
`Application Number` has unique values	Unique

Reproduction

Analysis started	2025-03-26 09:08:19.067901
Analysis finished	2025-03-26 09:09:45.242836
Duration	1 minute and 26.17 seconds
Software version	ydata-profiling vv4.15.1
Download configuration	config.json

Application Number
Real number (ℝ)

Unique

Distinct	1048532
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55001552

Minimum	10000007
Maximum	99999843
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	10000007
5-th percentile	14534332
Q1	32543755
median	54969147
Q3	77494357
95-th percentile	95506100
Maximum	99999843
Range	89999836
Interquartile range (IQR)	44950602

Descriptive statistics

Standard deviation	25969596
Coefficient of variation (CV)	0.47216115
Kurtosis	-1.1990249
Mean	55001552
Median Absolute Deviation (MAD)	22473804
Skewness	0.0012504182
Sum	5.7670887 × 10¹³
Variance	6.7441991 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
67950044	1	< 0.1%
67744287	1	< 0.1%
42296617	1	< 0.1%
29500167	1	< 0.1%
63899773	1	< 0.1%
49616861	1	< 0.1%
62701673	1	< 0.1%
22728552	1	< 0.1%
79809291	1	< 0.1%
86157511	1	< 0.1%
Other values (1048522)	1048522	> 99.9%

Value	Count	Frequency (%)
10000007	1	< 0.1%
10000035	1	< 0.1%
10000367	1	< 0.1%
10000419	1	< 0.1%
10000479	1	< 0.1%
10000487	1	< 0.1%
10000568	1	< 0.1%
10000594	1	< 0.1%
10000609	1	< 0.1%
10000612	1	< 0.1%

Value	Count	Frequency (%)
99999843	1	< 0.1%
99999802	1	< 0.1%
99999784	1	< 0.1%
99999712	1	< 0.1%
99999657	1	< 0.1%
99999581	1	< 0.1%
99999548	1	< 0.1%
99999491	1	< 0.1%
99999482	1	< 0.1%
99999451	1	< 0.1%

Gender
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.9 MiB

Male	577239
Female	461043
Other	10250

Length

Max length	6
Median length	4
Mean length	4.8891822
Min length	4

Characters and Unicode

Total characters	5126464
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Female
3rd row	Female
4th row	Female
5th row	Male

Common Values

Value	Count	Frequency (%)
Male	577239	55.1%
Female	461043	44.0%
Other	10250	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
male	577239	55.1%
female	461043	44.0%
other	10250	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	1509575	29.4%
a	1038282	20.3%
l	1038282	20.3%
M	577239	11.3%
F	461043	9.0%
m	461043	9.0%
O	10250	0.2%
t	10250	0.2%
h	10250	0.2%
r	10250	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5126464	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1509575	29.4%
a	1038282	20.3%
l	1038282	20.3%
M	577239	11.3%
F	461043	9.0%
m	461043	9.0%
O	10250	0.2%
t	10250	0.2%
h	10250	0.2%
r	10250	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5126464	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1509575	29.4%
a	1038282	20.3%
l	1038282	20.3%
M	577239	11.3%
F	461043	9.0%
m	461043	9.0%
O	10250	0.2%
t	10250	0.2%
h	10250	0.2%
r	10250	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5126464	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1509575	29.4%
a	1038282	20.3%
l	1038282	20.3%
M	577239	11.3%
F	461043	9.0%
m	461043	9.0%
O	10250	0.2%
t	10250	0.2%
h	10250	0.2%
r	10250	0.2%

State/UT
Categorical

Distinct	36
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	58.9 MiB

Gujarat	195808
Maharashtra	109263
Uttar Pradesh	99285
Rajasthan	86000
Karnataka	60194
Other values (31)	497982

Length

Max length	40
Median length	17
Mean length	9.887415
Min length	3

Characters and Unicode

Total characters	10367271
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Gujarat
2nd row	Uttarakhand
3rd row	Mizoram
4th row	Andhra Pradesh
5th row	Uttar Pradesh

Common Values

Value	Count	Frequency (%)
Gujarat	195808	18.7%
Maharashtra	109263	10.4%
Uttar Pradesh	99285	9.5%
Rajasthan	86000	8.2%
Karnataka	60194	5.7%
Telangana	59912	5.7%
Andhra Pradesh	55539	5.3%
Madhya Pradesh	39994	3.8%
Tamil Nadu	34667	3.3%
Haryana	20386	1.9%
Other values (26)	287484	27.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pradesh	211141	15.1%
gujarat	195808	14.0%
maharashtra	109263	7.8%
uttar	99285	7.1%
rajasthan	86000	6.1%
karnataka	60194	4.3%
telangana	59912	4.3%
andhra	55539	4.0%
and	41347	2.9%
madhya	39994	2.9%
Other values (37)	444235	31.7%

Most occurring characters

Value	Count	Frequency (%)
a	2615452	25.2%
r	1045863	10.1%
h	823400	7.9%
t	724073	7.0%
n	507667	4.9%
s	502082	4.8%
d	496825	4.8%
e	361473	3.5%
	354186	3.4%
u	319223	3.1%
Other values (33)	2617027	25.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10367271	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	2615452	25.2%
r	1045863	10.1%
h	823400	7.9%
t	724073	7.0%
n	507667	4.9%
s	502082	4.8%
d	496825	4.8%
e	361473	3.5%
	354186	3.4%
u	319223	3.1%
Other values (33)	2617027	25.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10367271	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	2615452	25.2%
r	1045863	10.1%
h	823400	7.9%
t	724073	7.0%
n	507667	4.9%
s	502082	4.8%
d	496825	4.8%
e	361473	3.5%
	354186	3.4%
u	319223	3.1%
Other values (33)	2617027	25.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10367271	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	2615452	25.2%
r	1045863	10.1%
h	823400	7.9%
t	724073	7.0%
n	507667	4.9%
s	502082	4.8%
d	496825	4.8%
e	361473	3.5%
	354186	3.4%
u	319223	3.1%
Other values (33)	2617027	25.2%

District
Text

Distinct	733
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.4 MiB

Length

Max length	26
Median length	22
Mean length	8.4202571
Min length	3

Characters and Unicode

Total characters	8828909
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Narmada
2nd row	Pauri Garhwal
3rd row	Kolasib
4th row	West Godavari
5th row	Deoria

Value	Count	Frequency (%)
north	19118	1.6%
south	17968	1.5%
west	11099	0.9%
east	10651	0.9%
sikkim	10608	0.9%
goa	10494	0.9%
mumbai	10417	0.9%
chandigarh	10156	0.8%
kachchh	9986	0.8%
mahisagar	9833	0.8%
Other values (736)	1093807	90.1%

Most occurring characters

Value	Count	Frequency (%)
a	1784338	20.2%
r	729616	8.3%
h	557852	6.3%
i	528349	6.0%
n	513719	5.8%
u	426407	4.8%
d	339034	3.8%
o	324505	3.7%
l	307012	3.5%
g	267837	3.0%
Other values (44)	3050240	34.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8828909	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1784338	20.2%
r	729616	8.3%
h	557852	6.3%
i	528349	6.0%
n	513719	5.8%
u	426407	4.8%
d	339034	3.8%
o	324505	3.7%
l	307012	3.5%
g	267837	3.0%
Other values (44)	3050240	34.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8828909	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1784338	20.2%
r	729616	8.3%
h	557852	6.3%
i	528349	6.0%
n	513719	5.8%
u	426407	4.8%
d	339034	3.8%
o	324505	3.7%
l	307012	3.5%
g	267837	3.0%
Other values (44)	3050240	34.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8828909	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1784338	20.2%
r	729616	8.3%
h	557852	6.3%
i	528349	6.0%
n	513719	5.8%
u	426407	4.8%
d	339034	3.8%
o	324505	3.7%
l	307012	3.5%
g	267837	3.0%
Other values (44)	3050240	34.5%

RWA/Residential
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	58.4 MiB

Residential	845451
RWA	203081

Length

Max length	11
Median length	11
Mean length	9.4505499
Min length	3

Characters and Unicode

Total characters	9909204
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Residential
2nd row	Residential
3rd row	Residential
4th row	Residential
5th row	Residential

Common Values

Value	Count	Frequency (%)
Residential	845451	80.6%
RWA	203081	19.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
residential	845451	80.6%
rwa	203081	19.4%

Most occurring characters

Value	Count	Frequency (%)
e	1690902	17.1%
i	1690902	17.1%
R	1048532	10.6%
s	845451	8.5%
d	845451	8.5%
n	845451	8.5%
t	845451	8.5%
a	845451	8.5%
l	845451	8.5%
W	203081	2.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9909204	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1690902	17.1%
i	1690902	17.1%
R	1048532	10.6%
s	845451	8.5%
d	845451	8.5%
n	845451	8.5%
t	845451	8.5%
a	845451	8.5%
l	845451	8.5%
W	203081	2.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9909204	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1690902	17.1%
i	1690902	17.1%
R	1048532	10.6%
s	845451	8.5%
d	845451	8.5%
n	845451	8.5%
t	845451	8.5%
a	845451	8.5%
l	845451	8.5%
W	203081	2.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9909204	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1690902	17.1%
i	1690902	17.1%
R	1048532	10.6%
s	845451	8.5%
d	845451	8.5%
n	845451	8.5%
t	845451	8.5%
a	845451	8.5%
l	845451	8.5%
W	203081	2.0%

Discom Name
Text

Distinct	56
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	96.6 MiB

Length

Max length	69
Median length	58
Mean length	47.591191
Min length	10

Characters and Unicode

Total characters	49900887
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Madhya Gujarat Vij Company Limited (MGVCL), Vadodara
2nd row	National Thermal Power Corporation (NTPC)
3rd row	PowerGrid Corporation of India
4th row	Andhra Pradesh Central Power Distribution Company Limited
5th row	Pashchimanchal Vidyut Vitran Nigam Limited (PVVNL), Meerut Zone

Value	Count	Frequency (%)
limited	701907	11.0%
company	444063	6.9%
power	323935	5.1%
corporation	249859	3.9%
distribution	222283	3.5%
electricity	196041	3.1%
of	184444	2.9%
vidyut	170801	2.7%
vij	151306	2.4%
gujarat	151306	2.4%
Other values (125)	3596368	56.3%

Most occurring characters

Value	Count	Frequency (%)
	5343781	10.7%
i	4254607	8.5%
a	3954272	7.9%
t	3300451	6.6%
r	3051753	6.1%
o	2639368	5.3%
n	2274916	4.6%
e	2267128	4.5%
d	1818478	3.6%
m	1717883	3.4%
Other values (41)	19278250	38.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	49900887	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	5343781	10.7%
i	4254607	8.5%
a	3954272	7.9%
t	3300451	6.6%
r	3051753	6.1%
o	2639368	5.3%
n	2274916	4.6%
e	2267128	4.5%
d	1818478	3.6%
m	1717883	3.4%
Other values (41)	19278250	38.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	49900887	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	5343781	10.7%
i	4254607	8.5%
a	3954272	7.9%
t	3300451	6.6%
r	3051753	6.1%
o	2639368	5.3%
n	2274916	4.6%
e	2267128	4.5%
d	1818478	3.6%
m	1717883	3.4%
Other values (41)	19278250	38.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	49900887	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	5343781	10.7%
i	4254607	8.5%
a	3954272	7.9%
t	3300451	6.6%
r	3051753	6.1%
o	2639368	5.3%
n	2274916	4.6%
e	2267128	4.5%
d	1818478	3.6%
m	1717883	3.4%
Other values (41)	19278250	38.6%

Acceptance Status
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.0 MiB

Rejected	736435
Accepted	312097

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	8388256
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Accepted
2nd row	Rejected
3rd row	Rejected
4th row	Accepted
5th row	Accepted

Common Values

Value	Count	Frequency (%)
Rejected	736435	70.2%
Accepted	312097	29.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rejected	736435	70.2%
accepted	312097	29.8%

Most occurring characters

Value	Count	Frequency (%)
e	2833499	33.8%
c	1360629	16.2%
d	1048532	12.5%
t	1048532	12.5%
j	736435	8.8%
R	736435	8.8%
A	312097	3.7%
p	312097	3.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8388256	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	2833499	33.8%
c	1360629	16.2%
d	1048532	12.5%
t	1048532	12.5%
j	736435	8.8%
R	736435	8.8%
A	312097	3.7%
p	312097	3.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8388256	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	2833499	33.8%
c	1360629	16.2%
d	1048532	12.5%
t	1048532	12.5%
j	736435	8.8%
R	736435	8.8%
A	312097	3.7%
p	312097	3.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8388256	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	2833499	33.8%
c	1360629	16.2%
d	1048532	12.5%
t	1048532	12.5%
j	736435	8.8%
R	736435	8.8%
A	312097	3.7%
p	312097	3.7%

Production Capacity (KW)
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.0 MiB

3 - 4 KW	735530
4 - 5 KW	153223
5 - 6 KW	77009
2 - 3 KW	57922
Above 6 KW	20859

Length

Max length	10
Median length	8
Mean length	8.0397871
Min length	8

Characters and Unicode

Total characters	8429974
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3 - 4 KW
2nd row	3 - 4 KW
3rd row	4 - 5 KW
4th row	3 - 4 KW
5th row	3 - 4 KW

Common Values

Value	Count	Frequency (%)
3 - 4 KW	735530	70.1%
4 - 5 KW	153223	14.6%
5 - 6 KW	77009	7.3%
2 - 3 KW	57922	5.5%
Above 6 KW	20859	2.0%
1 - 2 KW	3989	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
kw	1048532	25.1%
	1027673	24.6%
4	888753	21.3%
3	793452	19.0%
5	230232	5.5%
6	97868	2.3%
2	61911	1.5%
above	20859	0.5%
1	3989	0.1%

Most occurring characters

Value	Count	Frequency (%)
	3124737	37.1%
W	1048532	12.4%
K	1048532	12.4%
-	1027673	12.2%
4	888753	10.5%
3	793452	9.4%
5	230232	2.7%
6	97868	1.2%
2	61911	0.7%
A	20859	0.2%
Other values (5)	87425	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8429974	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	3124737	37.1%
W	1048532	12.4%
K	1048532	12.4%
-	1027673	12.2%
4	888753	10.5%
3	793452	9.4%
5	230232	2.7%
6	97868	1.2%
2	61911	0.7%
A	20859	0.2%
Other values (5)	87425	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8429974	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	3124737	37.1%
W	1048532	12.4%
K	1048532	12.4%
-	1027673	12.2%
4	888753	10.5%
3	793452	9.4%
5	230232	2.7%
6	97868	1.2%
2	61911	0.7%
A	20859	0.2%
Other values (5)	87425	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8429974	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	3124737	37.1%
W	1048532	12.4%
K	1048532	12.4%
-	1027673	12.2%
4	888753	10.5%
3	793452	9.4%
5	230232	2.7%
6	97868	1.2%
2	61911	0.7%
A	20859	0.2%
Other values (5)	87425	1.0%

Vendor Organization
Categorical

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	67.9 MiB

SkyPower Solar	82812
BrightSun Power	78571
GreenSpark Solar	74629
RadiantSun Energy	74060
SunWave Energy	69912
Other values (15)	668548

Length

Max length	27
Median length	23
Mean length	18.875474
Min length	13

Characters and Unicode

Total characters	19791539
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SolarCrest Enterprises
2nd row	BrightSun Power
3rd row	InfiniteLight Solar
4th row	SunVolt Power
5th row	SunRise Renewable Solutions

Common Values

Value	Count	Frequency (%)
SkyPower Solar	82812	7.9%
BrightSun Power	78571	7.5%
GreenSpark Solar	74629	7.1%
RadiantSun Energy	74060	7.1%
SunWave Energy	69912	6.7%
SunTech Solar Solutions	65786	6.3%
SunRise Renewable Solutions	60942	5.8%
SolarHarvest Energy	56581	5.4%
SolarPeak Innovations	56434	5.4%
InfiniteLight Solar	52434	5.0%
Other values (10)	376371	35.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
solar	341459	14.9%
energy	231033	10.1%
solutions	157208	6.9%
power	118122	5.1%
systems	105300	4.6%
technologies	96048	4.2%
skypower	82812	3.6%
enterprises	78724	3.4%
brightsun	78571	3.4%
greenspark	74629	3.3%
Other values (19)	929896	40.5%

Most occurring characters

Value	Count	Frequency (%)
e	2009669	10.2%
n	1736742	8.8%
r	1674249	8.5%
o	1550831	7.8%
S	1490668	7.5%
	1245270	6.3%
a	1196281	6.0%
l	1004818	5.1%
t	843008	4.3%
s	839122	4.2%
Other values (26)	6200881	31.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19791539	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	2009669	10.2%
n	1736742	8.8%
r	1674249	8.5%
o	1550831	7.8%
S	1490668	7.5%
	1245270	6.3%
a	1196281	6.0%
l	1004818	5.1%
t	843008	4.3%
s	839122	4.2%
Other values (26)	6200881	31.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19791539	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	2009669	10.2%
n	1736742	8.8%
r	1674249	8.5%
o	1550831	7.8%
S	1490668	7.5%
	1245270	6.3%
a	1196281	6.0%
l	1004818	5.1%
t	843008	4.3%
s	839122	4.2%
Other values (26)	6200881	31.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19791539	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	2009669	10.2%
n	1736742	8.8%
r	1674249	8.5%
o	1550831	7.8%
S	1490668	7.5%
	1245270	6.3%
a	1196281	6.0%
l	1004818	5.1%
t	843008	4.3%
s	839122	4.2%
Other values (26)	6200881	31.3%

Registration Date
Date

Distinct	366
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.0 MiB

Minimum	2024-01-01 00:00:00
Maximum	2024-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Application Approved Date
Text

Distinct	365
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.6 MiB

Length

Max length	10
Median length	8
Mean length	8.571973
Min length	7

Characters and Unicode

Total characters	8987988
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	15-11-2024
2nd row	Declined
3rd row	Declined
4th row	17-07-2024
5th row	29-12-2024

Value	Count	Frequency (%)
declined	736435	70.2%
pending	8154	0.8%
19-07-2024	1583	0.2%
28-07-2024	1558	0.1%
25-07-2024	1554	0.1%
18-07-2024	1553	0.1%
29-07-2024	1532	0.1%
30-07-2024	1529	0.1%
20-07-2024	1525	0.1%
02-08-2024	1518	0.1%
Other values (355)	291591	27.8%

Most occurring characters

Value	Count	Frequency (%)
e	1481024	16.5%
2	783449	8.7%
n	752743	8.4%
d	744589	8.3%
i	744589	8.3%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	657618	7.3%
-	607886	6.8%
Other values (10)	1006785	11.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8987988	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1481024	16.5%
2	783449	8.7%
n	752743	8.4%
d	744589	8.3%
i	744589	8.3%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	657618	7.3%
-	607886	6.8%
Other values (10)	1006785	11.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8987988	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1481024	16.5%
2	783449	8.7%
n	752743	8.4%
d	744589	8.3%
i	744589	8.3%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	657618	7.3%
-	607886	6.8%
Other values (10)	1006785	11.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8987988	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1481024	16.5%
2	783449	8.7%
n	752743	8.4%
d	744589	8.3%
i	744589	8.3%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	657618	7.3%
-	607886	6.8%
Other values (10)	1006785	11.2%

Vendor Selection Date
Text

Distinct	360
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.5 MiB

Length

Max length	10
Median length	8
Mean length	8.5463744
Min length	7

Characters and Unicode

Total characters	8961147
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	26-11-2024
2nd row	Declined
3rd row	Declined
4th row	26-07-2024
5th row	Pending

Value	Count	Frequency (%)
declined	736435	70.2%
pending	17101	1.6%
08-08-2024	1617	0.2%
03-08-2024	1557	0.1%
09-08-2024	1545	0.1%
05-08-2024	1541	0.1%
04-08-2024	1530	0.1%
10-08-2024	1530	0.1%
30-07-2024	1518	0.1%
28-07-2024	1518	0.1%
Other values (350)	282640	27.0%

Most occurring characters

Value	Count	Frequency (%)
e	1489971	16.6%
n	770637	8.6%
2	764594	8.5%
d	753536	8.4%
i	753536	8.4%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	636994	7.1%
-	589992	6.6%
Other values (10)	992582	11.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8961147	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1489971	16.6%
n	770637	8.6%
2	764594	8.5%
d	753536	8.4%
i	753536	8.4%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	636994	7.1%
-	589992	6.6%
Other values (10)	992582	11.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8961147	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1489971	16.6%
n	770637	8.6%
2	764594	8.5%
d	753536	8.4%
i	753536	8.4%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	636994	7.1%
-	589992	6.6%
Other values (10)	992582	11.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8961147	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1489971	16.6%
n	770637	8.6%
2	764594	8.5%
d	753536	8.4%
i	753536	8.4%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	636994	7.1%
-	589992	6.6%
Other values (10)	992582	11.1%

Vendor Acceptance Date
Text

Distinct	358
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.5 MiB

Length

Max length	10
Median length	8
Mean length	8.5347724
Min length	7

Characters and Unicode

Total characters	8948982
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	28-11-2024
2nd row	Declined
3rd row	Declined
4th row	02-08-2024
5th row	Pending

Value	Count	Frequency (%)
declined	736435	70.2%
pending	21156	2.0%
12-08-2024	1565	0.1%
08-08-2024	1565	0.1%
09-08-2024	1555	0.1%
13-08-2024	1526	0.1%
10-08-2024	1523	0.1%
02-08-2024	1521	0.1%
01-08-2024	1518	0.1%
16-08-2024	1504	0.1%
Other values (348)	278664	26.6%

Most occurring characters

Value	Count	Frequency (%)
e	1494026	16.7%
n	778747	8.7%
i	757591	8.5%
d	757591	8.5%
2	754545	8.4%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	628350	7.0%
-	581882	6.5%
Other values (10)	986945	11.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8948982	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1494026	16.7%
n	778747	8.7%
i	757591	8.5%
d	757591	8.5%
2	754545	8.4%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	628350	7.0%
-	581882	6.5%
Other values (10)	986945	11.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8948982	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1494026	16.7%
n	778747	8.7%
i	757591	8.5%
d	757591	8.5%
2	754545	8.4%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	628350	7.0%
-	581882	6.5%
Other values (10)	986945	11.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8948982	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1494026	16.7%
n	778747	8.7%
i	757591	8.5%
d	757591	8.5%
2	754545	8.4%
l	736435	8.2%
D	736435	8.2%
c	736435	8.2%
0	628350	7.0%
-	581882	6.5%
Other values (10)	986945	11.0%

Installation Date
Text

Distinct	344
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.4 MiB

Length

Max length	10
Median length	8
Mean length	8.4048708
Min length	7

Characters and Unicode

Total characters	8812776
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	09-12-2024
2nd row	Declined
3rd row	Declined
4th row	13-09-2024
5th row	Pending

Value	Count	Frequency (%)
declined	736435	70.2%
pending	66558	6.3%
02-09-2024	1436	0.1%
07-09-2024	1432	0.1%
05-09-2024	1419	0.1%
06-09-2024	1409	0.1%
03-09-2024	1407	0.1%
08-09-2024	1392	0.1%
31-08-2024	1386	0.1%
09-09-2024	1374	0.1%
Other values (334)	234284	22.3%

Most occurring characters

Value	Count	Frequency (%)
e	1539428	17.5%
n	869551	9.9%
i	802993	9.1%
d	802993	9.1%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	618584	7.0%
0	542079	6.2%
-	491078	5.6%
Other values (10)	936765	10.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8812776	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1539428	17.5%
n	869551	9.9%
i	802993	9.1%
d	802993	9.1%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	618584	7.0%
0	542079	6.2%
-	491078	5.6%
Other values (10)	936765	10.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8812776	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1539428	17.5%
n	869551	9.9%
i	802993	9.1%
d	802993	9.1%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	618584	7.0%
0	542079	6.2%
-	491078	5.6%
Other values (10)	936765	10.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8812776	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1539428	17.5%
n	869551	9.9%
i	802993	9.1%
d	802993	9.1%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	618584	7.0%
0	542079	6.2%
-	491078	5.6%
Other values (10)	936765	10.6%

Inspection Date
Text

Distinct	350
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.4 MiB

Length

Max length	10
Median length	8
Mean length	8.4048708
Min length	7

Characters and Unicode

Total characters	8812776
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	17-12-2024
2nd row	Declined
3rd row	Declined
4th row	20-09-2024
5th row	Pending

Value	Count	Frequency (%)
declined	736435	70.2%
pending	66558	6.3%
15-09-2024	1453	0.1%
13-09-2024	1426	0.1%
07-09-2024	1415	0.1%
11-09-2024	1393	0.1%
06-09-2024	1388	0.1%
12-09-2024	1387	0.1%
19-09-2024	1383	0.1%
22-09-2024	1381	0.1%
Other values (340)	234313	22.3%

Most occurring characters

Value	Count	Frequency (%)
e	1539428	17.5%
n	869551	9.9%
i	802993	9.1%
d	802993	9.1%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	619336	7.0%
0	540567	6.1%
-	491078	5.6%
Other values (10)	937525	10.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8812776	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1539428	17.5%
n	869551	9.9%
i	802993	9.1%
d	802993	9.1%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	619336	7.0%
0	540567	6.1%
-	491078	5.6%
Other values (10)	937525	10.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8812776	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1539428	17.5%
n	869551	9.9%
i	802993	9.1%
d	802993	9.1%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	619336	7.0%
0	540567	6.1%
-	491078	5.6%
Other values (10)	937525	10.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8812776	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1539428	17.5%
n	869551	9.9%
i	802993	9.1%
d	802993	9.1%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	619336	7.0%
0	540567	6.1%
-	491078	5.6%
Other values (10)	937525	10.6%

Subsidy Redeemed Date
Text

Distinct	356
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.4 MiB

Length

Max length	10
Median length	8
Mean length	8.38997
Min length	7

Characters and Unicode

Total characters	8797152
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	05-01-2025
2nd row	Declined
3rd row	Declined
4th row	04-10-2024
5th row	Pending

Value	Count	Frequency (%)
declined	736435	70.2%
pending	71766	6.8%
02-10-2024	1383	0.1%
05-10-2024	1373	0.1%
25-09-2024	1373	0.1%
03-10-2024	1365	0.1%
04-10-2024	1358	0.1%
28-09-2024	1331	0.1%
29-09-2024	1322	0.1%
06-10-2024	1322	0.1%
Other values (346)	229504	21.9%

Most occurring characters

Value	Count	Frequency (%)
e	1544636	17.6%
n	879967	10.0%
i	808201	9.2%
d	808201	9.2%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	607995	6.9%
0	523504	6.0%
-	480662	5.5%
Other values (10)	934681	10.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8797152	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1544636	17.6%
n	879967	10.0%
i	808201	9.2%
d	808201	9.2%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	607995	6.9%
0	523504	6.0%
-	480662	5.5%
Other values (10)	934681	10.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8797152	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1544636	17.6%
n	879967	10.0%
i	808201	9.2%
d	808201	9.2%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	607995	6.9%
0	523504	6.0%
-	480662	5.5%
Other values (10)	934681	10.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8797152	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1544636	17.6%
n	879967	10.0%
i	808201	9.2%
d	808201	9.2%
l	736435	8.4%
c	736435	8.4%
D	736435	8.4%
2	607995	6.9%
0	523504	6.0%
-	480662	5.5%
Other values (10)	934681	10.6%

Subsidy Released Date
Text

Distinct	285
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	57.0 MiB

Length

Max length	10
Median length	8
Mean length	7.9955786
Min length	7

Characters and Unicode

Total characters	8383620
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	Pending
2nd row	Declined
3rd row	Declined
4th row	Pending
5th row	Pending

Value	Count	Frequency (%)
declined	736435	70.2%
pending	209610	20.0%
06-11-2024	728	0.1%
18-11-2024	707	0.1%
12-11-2024	701	0.1%
26-11-2024	687	0.1%
01-11-2024	685	0.1%
21-11-2024	684	0.1%
07-11-2024	683	0.1%
10-11-2024	682	0.1%
Other values (275)	96930	9.2%

Most occurring characters

Value	Count	Frequency (%)
e	1682480	20.1%
n	1155655	13.8%
i	946045	11.3%
d	946045	11.3%
l	736435	8.8%
c	736435	8.8%
D	736435	8.8%
2	268527	3.2%
g	209610	2.5%
P	209610	2.5%
Other values (10)	756343	9.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8383620	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1682480	20.1%
n	1155655	13.8%
i	946045	11.3%
d	946045	11.3%
l	736435	8.8%
c	736435	8.8%
D	736435	8.8%
2	268527	3.2%
g	209610	2.5%
P	209610	2.5%
Other values (10)	756343	9.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8383620	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1682480	20.1%
n	1155655	13.8%
i	946045	11.3%
d	946045	11.3%
l	736435	8.8%
c	736435	8.8%
D	736435	8.8%
2	268527	3.2%
g	209610	2.5%
P	209610	2.5%
Other values (10)	756343	9.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8383620	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1682480	20.1%
n	1155655	13.8%
i	946045	11.3%
d	946045	11.3%
l	736435	8.8%
c	736435	8.8%
D	736435	8.8%
2	268527	3.2%
g	209610	2.5%
P	209610	2.5%
Other values (10)	756343	9.0%

Registration to Approval Days
Categorical

High correlation Missing

Distinct	14
Distinct (%)	< 0.1%
Missing	736435
Missing (%)	70.2%
Memory size	54.4 MiB

6	23933
7	23750
5	23656
8	23508
10	23486
Other values (9)	193764

Length

Max length	7
Median length	2
Mean length	1.6765621
Min length	1

Characters and Unicode

Total characters	523250
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	13
2nd row	14
3rd row	9
4th row	14
5th row	8

Common Values

Value	Count	Frequency (%)
6	23933	2.3%
7	23750	2.3%
5	23656	2.3%
8	23508	2.2%
10	23486	2.2%
9	23455	2.2%
4	23412	2.2%
11	23374	2.2%
12	23323	2.2%
13	23249	2.2%
Other values (4)	76951	7.3%
(Missing)	736435	70.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
6	23933	7.7%
7	23750	7.6%
5	23656	7.6%
8	23508	7.5%
10	23486	7.5%
9	23455	7.5%
4	23412	7.5%
11	23374	7.5%
12	23323	7.5%
13	23249	7.4%
Other values (4)	76951	24.7%

Most occurring characters

Value	Count	Frequency (%)
1	185603	35.5%
5	46778	8.9%
6	46631	8.9%
4	46389	8.9%
7	23750	4.5%
8	23508	4.5%
0	23486	4.5%
9	23455	4.5%
2	23323	4.5%
3	23249	4.4%
Other values (6)	57078	10.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	523250	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	185603	35.5%
5	46778	8.9%
6	46631	8.9%
4	46389	8.9%
7	23750	4.5%
8	23508	4.5%
0	23486	4.5%
9	23455	4.5%
2	23323	4.5%
3	23249	4.4%
Other values (6)	57078	10.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	523250	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	185603	35.5%
5	46778	8.9%
6	46631	8.9%
4	46389	8.9%
7	23750	4.5%
8	23508	4.5%
0	23486	4.5%
9	23455	4.5%
2	23323	4.5%
3	23249	4.4%
Other values (6)	57078	10.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	523250	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	185603	35.5%
5	46778	8.9%
6	46631	8.9%
4	46389	8.9%
7	23750	4.5%
8	23508	4.5%
0	23486	4.5%
9	23455	4.5%
2	23323	4.5%
3	23249	4.4%
Other values (6)	57078	10.9%

Approval to Vendor Selection Days
Categorical

High correlation Missing

Distinct	12
Distinct (%)	< 0.1%
Missing	736435
Missing (%)	70.2%
Memory size	54.5 MiB

7	27335
9	27179
6	27149
8	26935
11	26873
Other values (7)	176626

Length

Max length	7
Median length	2
Mean length	1.926007
Min length	1

Characters and Unicode

Total characters	601101
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	12
2nd row	10
3rd row	Pending
4th row	7
5th row	6

Common Values

Value	Count	Frequency (%)
7	27335	2.6%
9	27179	2.6%
6	27149	2.6%
8	26935	2.6%
11	26873	2.6%
10	26813	2.6%
15	26714	2.5%
12	26606	2.5%
13	26554	2.5%
16	26435	2.5%
Other values (2)	43504	4.1%
(Missing)	736435	70.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
7	27335	8.8%
9	27179	8.7%
6	27149	8.7%
8	26935	8.6%
11	26873	8.6%
10	26813	8.6%
15	26714	8.6%
12	26606	8.5%
13	26554	8.5%
16	26435	8.5%
Other values (2)	43504	13.9%

Most occurring characters

Value	Count	Frequency (%)
1	213271	35.5%
6	53584	8.9%
n	34202	5.7%
7	27335	4.5%
9	27179	4.5%
8	26935	4.5%
0	26813	4.5%
5	26714	4.4%
2	26606	4.4%
3	26554	4.4%
Other values (6)	111908	18.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	601101	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	213271	35.5%
6	53584	8.9%
n	34202	5.7%
7	27335	4.5%
9	27179	4.5%
8	26935	4.5%
0	26813	4.5%
5	26714	4.4%
2	26606	4.4%
3	26554	4.4%
Other values (6)	111908	18.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	601101	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	213271	35.5%
6	53584	8.9%
n	34202	5.7%
7	27335	4.5%
9	27179	4.5%
8	26935	4.5%
0	26813	4.5%
5	26714	4.4%
2	26606	4.4%
3	26554	4.4%
Other values (6)	111908	18.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	601101	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	213271	35.5%
6	53584	8.9%
n	34202	5.7%
7	27335	4.5%
9	27179	4.5%
8	26935	4.5%
0	26813	4.5%
5	26714	4.4%
2	26606	4.4%
3	26554	4.4%
Other values (6)	111908	18.6%

Vendor Selection to Acceptance Days
Categorical

High correlation Missing

Distinct	7
Distinct (%)	< 0.1%
Missing	736435
Missing (%)	70.2%
Memory size	54.3 MiB

3	48759
6	48724
5	48550
7	48550
4	48449
Other values (2)	69065

Length

Max length	7
Median length	1
Mean length	1.4067197
Min length	1

Characters and Unicode

Total characters	439033
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	8
3rd row	Pending
4th row	3
5th row	3

Common Values

Value	Count	Frequency (%)
3	48759	4.7%
6	48724	4.6%
5	48550	4.6%
7	48550	4.6%
4	48449	4.6%
8	47909	4.6%
Pending	21156	2.0%
(Missing)	736435	70.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	48759	15.6%
6	48724	15.6%
5	48550	15.6%
7	48550	15.6%
4	48449	15.5%
8	47909	15.4%
pending	21156	6.8%

Most occurring characters

Value	Count	Frequency (%)
3	48759	11.1%
6	48724	11.1%
5	48550	11.1%
7	48550	11.1%
4	48449	11.0%
8	47909	10.9%
n	42312	9.6%
P	21156	4.8%
e	21156	4.8%
d	21156	4.8%
Other values (2)	42312	9.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	439033	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	48759	11.1%
6	48724	11.1%
5	48550	11.1%
7	48550	11.1%
4	48449	11.0%
8	47909	10.9%
n	42312	9.6%
P	21156	4.8%
e	21156	4.8%
d	21156	4.8%
Other values (2)	42312	9.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	439033	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	48759	11.1%
6	48724	11.1%
5	48550	11.1%
7	48550	11.1%
4	48449	11.0%
8	47909	10.9%
n	42312	9.6%
P	21156	4.8%
e	21156	4.8%
d	21156	4.8%
Other values (2)	42312	9.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	439033	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	48759	11.1%
6	48724	11.1%
5	48550	11.1%
7	48550	11.1%
4	48449	11.0%
8	47909	10.9%
n	42312	9.6%
P	21156	4.8%
e	21156	4.8%
d	21156	4.8%
Other values (2)	42312	9.6%

Acceptance to Installation Days
Categorical

High correlation Missing

Distinct	37
Distinct (%)	< 0.1%
Missing	736435
Missing (%)	70.2%
Memory size	54.8 MiB

Pending	66558
18	7085
13	7057
14	7049
26	6978
Other values (32)	217370

Length

Max length	7
Median length	2
Mean length	3.0663031
Min length	2

Characters and Unicode

Total characters	956984
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	12
2nd row	43
3rd row	Pending
4th row	36
5th row	38

Common Values

Value	Count	Frequency (%)
Pending	66558	6.3%
18	7085	0.7%
13	7057	0.7%
14	7049	0.7%
26	6978	0.7%
16	6975	0.7%
11	6975	0.7%
22	6968	0.7%
12	6960	0.7%
31	6953	0.7%
Other values (27)	182539	17.4%
(Missing)	736435	70.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pending	66558	21.3%
18	7085	2.3%
13	7057	2.3%
14	7049	2.3%
26	6978	2.2%
16	6975	2.2%
11	6975	2.2%
22	6968	2.2%
12	6960	2.2%
31	6953	2.2%
Other values (27)	182539	58.5%

Most occurring characters

Value	Count	Frequency (%)
n	133116	13.9%
2	95801	10.0%
3	95035	9.9%
1	90219	9.4%
4	73876	7.7%
d	66558	7.0%
e	66558	7.0%
P	66558	7.0%
i	66558	7.0%
g	66558	7.0%
Other values (6)	136147	14.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	956984	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	133116	13.9%
2	95801	10.0%
3	95035	9.9%
1	90219	9.4%
4	73876	7.7%
d	66558	7.0%
e	66558	7.0%
P	66558	7.0%
i	66558	7.0%
g	66558	7.0%
Other values (6)	136147	14.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	956984	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	133116	13.9%
2	95801	10.0%
3	95035	9.9%
1	90219	9.4%
4	73876	7.7%
d	66558	7.0%
e	66558	7.0%
P	66558	7.0%
i	66558	7.0%
g	66558	7.0%
Other values (6)	136147	14.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	956984	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	133116	13.9%
2	95801	10.0%
3	95035	9.9%
1	90219	9.4%
4	73876	7.7%
d	66558	7.0%
e	66558	7.0%
P	66558	7.0%
i	66558	7.0%
g	66558	7.0%
Other values (6)	136147	14.2%

Installation to Inspection Days
Categorical

High correlation Missing

Distinct	12
Distinct (%)	< 0.1%
Missing	736435
Missing (%)	70.2%
Memory size	54.7 MiB

Pending	66558
11	22552
6	22524
15	22508
10	22381
Other values (7)	155574

Length

Max length	7
Median length	2
Mean length	2.7800972
Min length	1

Characters and Unicode

Total characters	867660
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9
2nd row	8
3rd row	Pending
4th row	7
5th row	6

Common Values

Value	Count	Frequency (%)
Pending	66558	6.3%
11	22552	2.2%
6	22524	2.1%
15	22508	2.1%
10	22381	2.1%
7	22348	2.1%
9	22331	2.1%
12	22293	2.1%
14	22229	2.1%
13	22173	2.1%
Other values (2)	44200	4.2%
(Missing)	736435	70.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pending	66558	21.3%
11	22552	7.2%
6	22524	7.2%
15	22508	7.2%
10	22381	7.2%
7	22348	7.2%
9	22331	7.2%
12	22293	7.1%
14	22229	7.1%
13	22173	7.1%
Other values (2)	44200	14.2%

Most occurring characters

Value	Count	Frequency (%)
1	178767	20.6%
n	133116	15.3%
e	66558	7.7%
P	66558	7.7%
d	66558	7.7%
i	66558	7.7%
g	66558	7.7%
6	44603	5.1%
5	22508	2.6%
0	22381	2.6%
Other values (6)	133495	15.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	867660	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	178767	20.6%
n	133116	15.3%
e	66558	7.7%
P	66558	7.7%
d	66558	7.7%
i	66558	7.7%
g	66558	7.7%
6	44603	5.1%
5	22508	2.6%
0	22381	2.6%
Other values (6)	133495	15.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	867660	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	178767	20.6%
n	133116	15.3%
e	66558	7.7%
P	66558	7.7%
d	66558	7.7%
i	66558	7.7%
g	66558	7.7%
6	44603	5.1%
5	22508	2.6%
0	22381	2.6%
Other values (6)	133495	15.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	867660	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	178767	20.6%
n	133116	15.3%
e	66558	7.7%
P	66558	7.7%
d	66558	7.7%
i	66558	7.7%
g	66558	7.7%
6	44603	5.1%
5	22508	2.6%
0	22381	2.6%
Other values (6)	133495	15.4%

Inspection to Subsidy Redeemed Days
Categorical

High correlation Missing

Distinct	29
Distinct (%)	< 0.1%
Missing	736435
Missing (%)	70.2%
Memory size	54.8 MiB

Pending	71766
27	8775
29	8706
22	8681
31	8674
Other values (24)	205495

Length

Max length	7
Median length	2
Mean length	2.9851553
Min length	1

Characters and Unicode

Total characters	931658
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	20
2nd row	15
3rd row	Pending
4th row	11
5th row	4

Common Values

Value	Count	Frequency (%)
Pending	71766	6.8%
27	8775	0.8%
29	8706	0.8%
22	8681	0.8%
31	8674	0.8%
7	8668	0.8%
23	8649	0.8%
26	8649	0.8%
5	8647	0.8%
24	8639	0.8%
Other values (19)	162243	15.5%
(Missing)	736435	70.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pending	71766	23.0%
27	8775	2.8%
29	8706	2.8%
22	8681	2.8%
31	8674	2.8%
7	8668	2.8%
23	8649	2.8%
26	8649	2.8%
5	8647	2.8%
24	8639	2.8%
Other values (19)	162243	52.0%

Most occurring characters

Value	Count	Frequency (%)
n	143532	15.4%
1	110926	11.9%
2	103787	11.1%
e	71766	7.7%
d	71766	7.7%
i	71766	7.7%
g	71766	7.7%
P	71766	7.7%
3	34317	3.7%
7	25989	2.8%
Other values (6)	154277	16.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	931658	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	143532	15.4%
1	110926	11.9%
2	103787	11.1%
e	71766	7.7%
d	71766	7.7%
i	71766	7.7%
g	71766	7.7%
P	71766	7.7%
3	34317	3.7%
7	25989	2.8%
Other values (6)	154277	16.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	931658	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	143532	15.4%
1	110926	11.9%
2	103787	11.1%
e	71766	7.7%
d	71766	7.7%
i	71766	7.7%
g	71766	7.7%
P	71766	7.7%
3	34317	3.7%
7	25989	2.8%
Other values (6)	154277	16.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	931658	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	143532	15.4%
1	110926	11.9%
2	103787	11.1%
e	71766	7.7%
d	71766	7.7%
i	71766	7.7%
g	71766	7.7%
P	71766	7.7%
3	34317	3.7%
7	25989	2.8%
Other values (6)	154277	16.6%

Subsidy Redeemed to Released Days
Text

Missing

Distinct	152
Distinct (%)	< 0.1%
Missing	736435
Missing (%)	70.2%
Memory size	38.7 MiB

Length

Max length	7
Median length	7
Mean length	5.4995787
Min length	2

Characters and Unicode

Total characters	1716402
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pending
2nd row	Pending
3rd row	Pending
4th row	80
5th row	116

Value	Count	Frequency (%)
pending	209610	67.2%
39	972	0.3%
68	943	0.3%
44	943	0.3%
42	939	0.3%
34	935	0.3%
33	925	0.3%
31	918	0.3%
51	916	0.3%
36	913	0.3%
Other values (142)	94083	30.1%

Most occurring characters

Value	Count	Frequency (%)
n	419220	24.4%
P	209610	12.2%
e	209610	12.2%
d	209610	12.2%
i	209610	12.2%
g	209610	12.2%
1	61474	3.6%
4	24553	1.4%
3	24209	1.4%
5	23618	1.4%
Other values (6)	115278	6.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1716402	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	419220	24.4%
P	209610	12.2%
e	209610	12.2%
d	209610	12.2%
i	209610	12.2%
g	209610	12.2%
1	61474	3.6%
4	24553	1.4%
3	24209	1.4%
5	23618	1.4%
Other values (6)	115278	6.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1716402	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	419220	24.4%
P	209610	12.2%
e	209610	12.2%
d	209610	12.2%
i	209610	12.2%
g	209610	12.2%
1	61474	3.6%
4	24553	1.4%
3	24209	1.4%
5	23618	1.4%
Other values (6)	115278	6.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1716402	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	419220	24.4%
P	209610	12.2%
e	209610	12.2%
d	209610	12.2%
i	209610	12.2%
g	209610	12.2%
1	61474	3.6%
4	24553	1.4%
3	24209	1.4%
5	23618	1.4%
Other values (6)	115278	6.7%

Interactions

Correlations

	Acceptance Status	Acceptance to Installation Days	Application Number	Approval to Vendor Selection Days	Gender	Inspection to Subsidy Redeemed Days	Installation to Inspection Days	Production Capacity (KW)	RWA/Residential	Registration to Approval Days	State/UT	Vendor Organization	Vendor Selection to Acceptance Days
Acceptance Status	1.000	1.000	0.000	1.000	0.001	1.000	1.000	0.000	0.003	1.000	0.117	0.000	1.000
Acceptance to Installation Days	1.000	1.000	0.003	0.139	0.003	0.180	0.302	0.004	0.000	0.087	0.000	0.000	0.211
Application Number	0.000	0.003	1.000	0.001	0.002	0.000	0.002	0.000	0.001	0.000	0.002	0.000	0.000
Approval to Vendor Selection Days	1.000	0.139	0.001	1.000	0.000	0.133	0.139	0.000	0.000	0.205	0.001	0.003	0.365
Gender	0.001	0.003	0.002	0.000	1.000	0.005	0.003	0.000	0.001	0.000	0.002	0.001	0.001
Inspection to Subsidy Redeemed Days	1.000	0.180	0.000	0.133	0.005	1.000	0.287	0.004	0.002	0.083	0.000	0.000	0.201
Installation to Inspection Days	1.000	0.302	0.002	0.139	0.003	0.287	1.000	0.002	0.003	0.095	0.000	0.003	0.211
Production Capacity (KW)	0.000	0.004	0.000	0.000	0.000	0.004	0.002	1.000	0.000	0.000	0.000	0.002	0.000
RWA/Residential	0.003	0.000	0.001	0.000	0.001	0.002	0.003	0.000	1.000	0.002	0.056	0.000	0.000
Registration to Approval Days	1.000	0.087	0.000	0.205	0.000	0.083	0.095	0.000	0.002	1.000	0.002	0.002	0.248
State/UT	0.117	0.000	0.002	0.001	0.002	0.000	0.000	0.000	0.056	0.002	1.000	0.001	0.000
Vendor Organization	0.000	0.000	0.000	0.003	0.001	0.000	0.003	0.002	0.000	0.002	0.001	1.000	0.000
Vendor Selection to Acceptance Days	1.000	0.211	0.000	0.365	0.001	0.201	0.211	0.000	0.000	0.248	0.000	0.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	Application Number	Gender	State/UT	District	RWA/Residential	Discom Name	Acceptance Status	Production Capacity (KW)	Vendor Organization	Registration Date	Application Approved Date	Vendor Selection Date	Vendor Acceptance Date	Installation Date	Inspection Date	Subsidy Redeemed Date	Subsidy Released Date	Registration to Approval Days	Approval to Vendor Selection Days	Vendor Selection to Acceptance Days	Acceptance to Installation Days	Installation to Inspection Days	Inspection to Subsidy Redeemed Days	Subsidy Redeemed to Released Days
0	67744287	Female	Gujarat	Narmada	Residential	Madhya Gujarat Vij Company Limited (MGVCL), Vadodara	Accepted	3 - 4 KW	SolarCrest Enterprises	03-11-2024	15-11-2024	26-11-2024	28-11-2024	09-12-2024	17-12-2024	05-01-2025	Pending	13	12	3	12	9	20	Pending
1	42296617	Female	Uttarakhand	Pauri Garhwal	Residential	National Thermal Power Corporation (NTPC)	Rejected	3 - 4 KW	BrightSun Power	08-02-2024	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	29500167	Female	Mizoram	Kolasib	Residential	PowerGrid Corporation of India	Rejected	4 - 5 KW	InfiniteLight Solar	09-07-2024	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
3	50309883	Female	Andhra Pradesh	West Godavari	Residential	Andhra Pradesh Central Power Distribution Company Limited	Accepted	3 - 4 KW	SunVolt Power	04-07-2024	17-07-2024	26-07-2024	02-08-2024	13-09-2024	20-09-2024	04-10-2024	Pending	14	10	8	43	8	15	Pending
4	52005507	Male	Uttar Pradesh	Deoria	Residential	Pashchimanchal Vidyut Vitran Nigam Limited (PVVNL), Meerut Zone	Accepted	3 - 4 KW	SunRise Renewable Solutions	21-12-2024	29-12-2024	Pending	Pending	Pending	Pending	Pending	Pending	9	Pending	Pending	Pending	Pending	Pending	Pending
5	42294850	Female	Assam	Hailakandi	Residential	Assam Power Distribution Company Limited (APDCL)	Accepted	3 - 4 KW	SolarCrest Enterprises	21-02-2024	05-03-2024	11-03-2024	13-03-2024	17-04-2024	23-04-2024	03-05-2024	21-07-2024	14	7	3	36	7	11	80
6	30495058	Other	Andhra Pradesh	West Godavari	RWA	Andhra Pradesh Southern Power Distribution Company Limited	Rejected	3 - 4 KW	EcoSolar Enterprises	23-08-2024	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
7	65055130	Male	Gujarat	Mehsana	RWA	Paschim Gujarat Vij Company Limited (PGVCL), Rajkot	Rejected	3 - 4 KW	GreenSpark Solar	30-12-2024	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
8	37540089	Female	Haryana	Hisar	Residential	Uttar Haryana Bijli Vitran Nigam Limited (UHBVN)	Accepted	3 - 4 KW	InfiniteLight Solar	16-05-2024	23-05-2024	28-05-2024	30-05-2024	06-07-2024	11-07-2024	14-07-2024	06-11-2024	8	6	3	38	6	4	116
9	82718828	Male	Gujarat	Sabarkantha	Residential	Madhya Gujarat Vij Company Limited (MGVCL), Vadodara	Rejected	3 - 4 KW	SolarHarvest Energy	26-04-2024	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN

	Application Number	Gender	State/UT	District	RWA/Residential	Discom Name	Acceptance Status	Production Capacity (KW)	Vendor Organization	Registration Date	Application Approved Date	Vendor Selection Date	Vendor Acceptance Date	Installation Date	Inspection Date	Subsidy Redeemed Date	Subsidy Released Date	Registration to Approval Days	Approval to Vendor Selection Days	Vendor Selection to Acceptance Days	Acceptance to Installation Days	Installation to Inspection Days	Inspection to Subsidy Redeemed Days	Subsidy Redeemed to Released Days
1048522	56223592	Male	Maharashtra	Hingoli	Residential	Tata Power	Rejected	1 - 2 KW	SolarPeak Innovations	23-03-2024	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1048523	79457447	Male	Maharashtra	Chandrapur	Residential	Brihanmumbai Electric Supply and Transport (BEST)	Rejected	2 - 3 KW	SunVolt Power	07-10-2024	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1048524	99949149	Male	Jammu and Kashmir	Kulgam	Residential	Power Development Department, Jammu & Kashmir	Rejected	3 - 4 KW	BrightSun Power	16-11-2024	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1048525	56128621	Male	Maharashtra	Parbhani	Residential	Maharashtra State Electricity Distribution Company Limited (MSEDCL)	Accepted	3 - 4 KW	GreenSpark Solar	02-11-2024	05-11-2024	17-11-2024	22-11-2024	13-12-2024	19-12-2024	23-12-2024	Pending	4	13	6	22	7	5	Pending
1048526	83781938	Male	Haryana	Rewari	Residential	Uttar Haryana Bijli Vitran Nigam Limited (UHBVN)	Rejected	4 - 5 KW	SunRise Renewable Solutions	07-04-2024	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1048527	94752971	Female	Telangana	Nirmal	Residential	Northern Power Distribution Company of Telangana Limited (TSNPDCL)	Rejected	1 - 2 KW	SolarHarvest Energy	18-04-2024	Declined	Declined	Declined	Declined	Declined	Declined	Declined	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1048528	67790319	Male	Kerala	Ernakulam	RWA	Kerala State Electricity Board (KSEB)	Accepted	4 - 5 KW	BrightSun Power	14-09-2024	18-09-2024	02-10-2024	06-10-2024	04-11-2024	11-11-2024	01-12-2024	Pending	5	15	5	30	8	21	Pending
1048529	15189135	Female	Maharashtra	Pune	Residential	Adani Electricity Mumbai Limited	Accepted	3 - 4 KW	RadiantSun Energy	08-05-2024	20-05-2024	04-06-2024	08-06-2024	28-06-2024	07-07-2024	25-07-2024	14-12-2024	13	16	5	21	10	19	143
1048530	69607595	Female	Uttar Pradesh	Gorakhpur	Residential	Lucknow Electricity Supply Administration (LESA), Lucknow City	Accepted	3 - 4 KW	GreenSpark Solar	28-08-2024	01-09-2024	09-09-2024	14-09-2024	14-10-2024	23-10-2024	02-11-2024	Pending	5	9	6	31	10	11	Pending
1048531	67950044	Male	Rajasthan	Dholpur	Residential	Ajmer Vidyut Vitran Nigam Ltd	Accepted	3 - 4 KW	SunTech Solar Solutions	03-10-2024	18-10-2024	31-10-2024	04-11-2024	07-12-2024	20-12-2024	04-01-2025	Pending	16	14	5	34	14	16	Pending

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)